CREATE TABLE [dbo].[PublishMessageLog]
(
[PublishMessageLogKey] [uniqueidentifier] NOT NULL,
[PublishRequestKey] [uniqueidentifier] NOT NULL,
[PublishRequestDetailKey] [uniqueidentifier] NULL,
[PublishServerCode] [nchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MessageNumber] [int] NULL,
[MessageText] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MessageDateTime] [datetime] NOT NULL,
[Location] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DisplayFlag] [bit] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[PublishMessageLog] ADD CONSTRAINT [PK_PublishMessageLog] PRIMARY KEY CLUSTERED ([PublishMessageLogKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PublishMessageLog_PublishRequestDetailKey] ON [dbo].[PublishMessageLog] ([PublishRequestDetailKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PublishMessageLog_PublishRequestKey] ON [dbo].[PublishMessageLog] ([PublishRequestKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PublishMessageLog_PublishServerCode] ON [dbo].[PublishMessageLog] ([PublishServerCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PublishMessageLog] ADD CONSTRAINT [FK_PublishMessageLog_PublishRequest] FOREIGN KEY ([PublishRequestKey]) REFERENCES [dbo].[PublishRequest] ([PublishRequestKey])
GO
ALTER TABLE [dbo].[PublishMessageLog] ADD CONSTRAINT [FK_PublishMessageLog_PublishRequestDetail] FOREIGN KEY ([PublishRequestDetailKey]) REFERENCES [dbo].[PublishRequestDetail] ([PublishRequestDetailKey]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[PublishMessageLog] ADD CONSTRAINT [FK_PublishMessageLog_PublishServerRef] FOREIGN KEY ([PublishServerCode]) REFERENCES [dbo].[PublishServerRef] ([PublishServerCode])
GO